Tabela PhPack

Definicja tabeli PhPack

Name

PhPack

Code

PhPack

Comment

Opakowanie leku


Lista kolumn tabeli PhPack

Name

Code

PackID

PackID

ResourceID

ResourceID

Active

Active

Quantity

Quantity

MeasureUnitID

MeasureUnitID

PackUnitID

PackUnitID

EanCode

EanCode

Bazyl

Bazyl

Bloz

Bloz

EuRegistryNo

EuRegistryNo

PackStatus

PackStatus

Deleted

Deleted

PortionDef

PortionDef

PortionUnitID

PortionUnitID

ActiveIngrInPortion

ActiveIngrInPortion

ActiveIngrUnitID

ActiveIngrUnitID

PriceType

PriceType

PriceDT

PriceDT

PackRefunded

PackRefunded

PortionLimit

PortionLimit

PackLimit

PackLimit

VatRateID

VatRateID

JwcID

JwcID

BazylID

BazylID

Description

Description

RegisterDate

RegisterDate

Register

Register

RegistryNumber

RegistryNumber

Authorized

Authorized

HospitalPack

HospitalPack

OffPrizeSell

OffPrizeSell

OffPrizeWhole

OffPrizeWhole

OffPrizeDet

OffPrizeDet

OffPriceLimit

OffPriceLimit

OffPriceMax

OffPriceMax

HashCode

HashCode

ExternalID

ExternalID

DrugAccessCategoryID

DrugAccessCategoryID

DrugVersion

DrugVersion

GTIN

GTIN

onMarket

onMarket


Kolumna PackID tabeli PhPack

Definicja kolumny PackID tabeli PhPack

Name

PackID

Code

PackID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli PhPack

Definicja kolumny ResourceID tabeli PhPack

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli PhPack

Definicja kolumny Active tabeli PhPack

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w systemie


Kolumna Quantity tabeli PhPack

Definicja kolumny Quantity tabeli PhPack

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

Ilosc


Kolumna MeasureUnitID tabeli PhPack

Definicja kolumny MeasureUnitID tabeli PhPack

Name

MeasureUnitID

Code

MeasureUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID jednostki miary


Kolumna PackUnitID tabeli PhPack

Definicja kolumny PackUnitID tabeli PhPack

Name

PackUnitID

Code

PackUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID jednostki opakowania


Kolumna EanCode tabeli PhPack

Definicja kolumny EanCode tabeli PhPack

Name

EanCode

Code

EanCode

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kod EAN (kod kreskowy)


Kolumna Bazyl tabeli PhPack

Definicja kolumny Bazyl tabeli PhPack

Name

Bazyl

Code

Bazyl

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer BAZYL


Kolumna Bloz tabeli PhPack

Definicja kolumny Bloz tabeli PhPack

Name

Bloz

Code

Bloz

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer BLOZ


Kolumna EuRegistryNo tabeli PhPack

Definicja kolumny EuRegistryNo tabeli PhPack

Name

EuRegistryNo

Code

EuRegistryNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer rejestru Unii Europejskiej


Kolumna PackStatus tabeli PhPack

Definicja kolumny PackStatus tabeli PhPack

Name

PackStatus

Code

PackStatus

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Status opakowania


Kolumna Deleted tabeli PhPack

Definicja kolumny Deleted tabeli PhPack

Name

Deleted

Code

Deleted

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga usuniecia


Kolumna PortionDef tabeli PhPack

Definicja kolumny PortionDef tabeli PhPack

Name

PortionDef

Code

PortionDef

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Definicja porcji


Kolumna PortionUnitID tabeli PhPack

Definicja kolumny PortionUnitID tabeli PhPack

Name

PortionUnitID

Code

PortionUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki definicji porcji


Kolumna ActiveIngrInPortion tabeli PhPack

Definicja kolumny ActiveIngrInPortion tabeli PhPack

Name

ActiveIngrInPortion

Code

ActiveIngrInPortion

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc skladnika aktywnego w porcji


Kolumna ActiveIngrUnitID tabeli PhPack

Definicja kolumny ActiveIngrUnitID tabeli PhPack

Name

ActiveIngrUnitID

Code

ActiveIngrUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki ilosci skladnika aktywnego w porcji


Kolumna PriceType tabeli PhPack

Definicja kolumny PriceType tabeli PhPack

Name

PriceType

Code

PriceType

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Typ ceny


Kolumna PriceDT tabeli PhPack

Definicja kolumny PriceDT tabeli PhPack

Name

PriceDT

Code

PriceDT

Data Type

DATE

Mandatory

No

Comment

Data ustalenia ceny


Kolumna PackRefunded tabeli PhPack

Definicja kolumny PackRefunded tabeli PhPack

Name

PackRefunded

Code

PackRefunded

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga refundacji leku


Kolumna PortionLimit tabeli PhPack

Definicja kolumny PortionLimit tabeli PhPack

Name

PortionLimit

Code

PortionLimit

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Limit porcji


Kolumna PackLimit tabeli PhPack

Definicja kolumny PackLimit tabeli PhPack

Name

PackLimit

Code

PackLimit

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Limit opakowania


Kolumna VatRateID tabeli PhPack

Definicja kolumny VatRateID tabeli PhPack

Name

VatRateID

Code

VatRateID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID stawki VAT


Kolumna JwcID tabeli PhPack

Definicja kolumny JwcID tabeli PhPack

Name

JwcID

Code

JwcID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID ze slownika JWC


Kolumna BazylID tabeli PhPack

Definicja kolumny BazylID tabeli PhPack

Name

BazylID

Code

BazylID

Data Type

VARCHAR2(6)

Mandatory

No

Comment

ID ze slownika BAZYL


Kolumna Description tabeli PhPack

Definicja kolumny Description tabeli PhPack

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis


Kolumna RegisterDate tabeli PhPack

Definicja kolumny RegisterDate tabeli PhPack

Name

RegisterDate

Code

RegisterDate

Data Type

DATE

Mandatory

No

Comment

Data wpisania leku do rejestru


Kolumna Register tabeli PhPack

Definicja kolumny Register tabeli PhPack

Name

Register

Code

Register

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa rejestru


Kolumna RegistryNumber tabeli PhPack

Definicja kolumny RegistryNumber tabeli PhPack

Name

RegistryNumber

Code

RegistryNumber

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer rejestru


Kolumna Authorized tabeli PhPack

Definicja kolumny Authorized tabeli PhPack

Name

Authorized

Code

Authorized

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Produkt dopuszczony do obrotu


Kolumna HospitalPack tabeli PhPack

Definicja kolumny HospitalPack tabeli PhPack

Name

HospitalPack

Code

HospitalPack

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Opakowanie szpitalne


Kolumna OffPrizeSell tabeli PhPack

Definicja kolumny OffPrizeSell tabeli PhPack

Name

OffPrizeSell

Code

OffPrizeSell

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena urzedowa zbytu


Kolumna OffPrizeWhole tabeli PhPack

Definicja kolumny OffPrizeWhole tabeli PhPack

Name

OffPrizeWhole

Code

OffPrizeWhole

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena urzedowa hurt


Kolumna OffPrizeDet tabeli PhPack

Definicja kolumny OffPrizeDet tabeli PhPack

Name

OffPrizeDet

Code

OffPrizeDet

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena urzedowa detal


Kolumna OffPriceLimit tabeli PhPack

Definicja kolumny OffPriceLimit tabeli PhPack

Name

OffPriceLimit

Code

OffPriceLimit

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena limitu


Kolumna OffPriceMax tabeli PhPack

Definicja kolumny OffPriceMax tabeli PhPack

Name

OffPriceMax

Code

OffPriceMax

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena maksymalna


Kolumna HashCode tabeli PhPack

Definicja kolumny HashCode tabeli PhPack

Name

HashCode

Code

HashCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Skrót z pól rekordu


Kolumna ExternalID tabeli PhPack

Definicja kolumny ExternalID tabeli PhPack

Name

ExternalID

Code

ExternalID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

Zewnetrzny identyfikator


Kolumna DrugAccessCategoryID tabeli PhPack

Definicja kolumny DrugAccessCategoryID tabeli PhPack

Name

DrugAccessCategoryID

Code

DrugAccessCategoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DrugVersion tabeli PhPack

Definicja kolumny DrugVersion tabeli PhPack

Name

DrugVersion

Code

DrugVersion

Data Type

DATE

Mandatory

No

Comment

 


Kolumna GTIN tabeli PhPack

Definicja kolumny GTIN tabeli PhPack

Name

GTIN

Code

GTIN

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod GTIN produktu Globalny Numer Jednostki Handlowej


Kolumna onMarket tabeli PhPack

Definicja kolumny onMarket tabeli PhPack

Name

onMarket

Code

onMarket

Data Type

NUMBER(3)

Mandatory

No

Comment

obecnosci produktu na rynku farmaceutycznym w Polsce w okresie ostatnich pelnych 3 miesiecy


Lista kluczy tabeli PhPack

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhPack

Definicja klucza Key_1 tabeli PhPack

Name

Key_1

Code

Key_1

Primary

Yes

Comment